<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_delivery_order`;");
E_C("CREATE TABLE `ecs_delivery_order` (
  `delivery_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_sn` varchar(20) NOT NULL,
  `order_sn` varchar(20) NOT NULL,
  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `invoice_no` varchar(50) DEFAULT NULL,
  `add_time` int(10) unsigned DEFAULT '0',
  `shipping_id` tinyint(3) unsigned DEFAULT '0',
  `shipping_name` varchar(120) DEFAULT NULL,
  `user_id` mediumint(8) unsigned DEFAULT '0',
  `action_user` varchar(30) DEFAULT NULL,
  `consignee` varchar(60) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `country` smallint(5) unsigned DEFAULT '0',
  `province` smallint(5) unsigned DEFAULT '0',
  `city` smallint(5) unsigned DEFAULT '0',
  `district` smallint(5) unsigned DEFAULT '0',
  `sign_building` varchar(120) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `zipcode` varchar(60) DEFAULT NULL,
  `tel` varchar(60) DEFAULT NULL,
  `mobile` varchar(60) DEFAULT NULL,
  `best_time` varchar(120) DEFAULT NULL,
  `postscript` varchar(255) DEFAULT NULL,
  `how_oos` varchar(120) DEFAULT NULL,
  `insure_fee` decimal(10,2) unsigned DEFAULT '0.00',
  `shipping_fee` decimal(10,2) unsigned DEFAULT '0.00',
  `update_time` int(10) unsigned DEFAULT '0',
  `suppliers_id` smallint(5) DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `agency_id` smallint(5) unsigned DEFAULT '0',
  PRIMARY KEY (`delivery_id`),
  KEY `user_id` (`user_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_delivery_order` values('31','20140918095127401','2014091899507','1','20140910054967515','1411033867','1','申通快递','13','admin','李女士','A街303号','1','2','52','500','','','','010-1234-234','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1411033892','0','0','0');");
E_D("replace into `ecs_delivery_order` values('32','20140918095216110','2014091899507','1','20140910054967515','1411033867','1','申通快递','13','admin','李女士','A街303号','1','2','52','500','','','','010-1234-234','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1411033955','0','0','0');");
E_D("replace into `ecs_delivery_order` values('48','20141205072523651','2014120589245','8','','1417764006','3','圆通速递','39','dongcheng_kuguan','东城','东城测试','1','2','52','500','','','','--','13555555555','仅工作日送货','','等待所有商品备齐后再发','0.00','5.00','1417764339','0','2','0');");
E_D("replace into `ecs_delivery_order` values('47','20141205071696955','2014120565245','6','2014120565245','1417763618','1','申通快递','39','beicangku','用户1','某街道122号','1','10','145','1195','','','111111','--','13333333333','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1417763798','0','0','0');");
E_D("replace into `ecs_delivery_order` values('35','20140918100496114','2014091828384','4','668815034603','1411034195','1','申通快递','13','admin','李女士','A街303号','1','2','52','500','','','','010-1234-234','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1411034672','0','0','0');");
E_D("replace into `ecs_delivery_order` values('36','20140918100583221','2014091828384','4','668815034603','1411034195','1','申通快递','13','admin','李女士','A街303号','1','2','52','500','','','','010-1234-234','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1411034732','0','0','0');");
E_D("replace into `ecs_delivery_order` values('37','20140918100598080','2014091895216','5','668815034603','1411034195','1','申通快递','13','admin','李女士','A街303号','1','2','52','500','','','','010-1234-234','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1411034735','0','0','0');");
E_D("replace into `ecs_delivery_order` values('38','20140918100651035','2014091895216','5','668815034603','1411034195','1','申通快递','13','admin','李女士','A街303号','1','2','52','500','','','','010-1234-234','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1411034795','0','0','0');");
E_D("replace into `ecs_delivery_order` values('39','20140919010523967','2014091925062','6','668815034603','1411088666','1','申通快递','16','admin','陈小姐','海淀区中街103号','1','2','52','502','','','','--','13333333333','工作日/周末/假日均可','','等待所有商品备齐后再发','0.00','0.00','1411088718','0','0','0');");
E_D("replace into `ecs_delivery_order` values('40','20140919010625586','2014091925062','6','668815034603','1411088666','1','申通快递','16','admin','陈小姐','海淀区中街103号','1','2','52','502','','','','--','13333333333','工作日/周末/假日均可','','等待所有商品备齐后再发','0.00','0.00','1411088778','0','0','0');");
E_D("replace into `ecs_delivery_order` values('41','20141126045587481','2014112631958','234','2014112631958','1416971112','3','圆通速递','34','admin','饿死各方人士','时光隧道喝点红糖','1','2','52','500','','','000000','--','15066057811','仅工作日送货','','等待所有商品备齐后再发','0.00','5.00','1416977737','0','0','0');");
E_D("replace into `ecs_delivery_order` values('42','20141204084282152','2014120448010','265',NULL,'1417682254','1','申通快递','26','admin','2222','爱哪哪','1','10','145','1194','','','131101','15342343568--','','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1417682530','0','2','0');");
E_D("replace into `ecs_delivery_order` values('43','20141205062289395','2014120597757','2','2014120597757','1417760104','1','申通快递','39','beicangku','用户1','某街道122号','1','10','145','1195','','','111111','--','13333333333','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1417760535','0','0','0');");
E_D("replace into `ecs_delivery_order` values('44','20141205062588025','2014120527272','1','2014120527272','1417759999','3','圆通速递','39','beicangku','用户1','某街道122号','1','10','145','1195','','','111111','--','13333333333','仅工作日送货','','与店主协商','0.00','5.00','1417760757','0','0','0');");
E_D("replace into `ecs_delivery_order` values('46','20141205071009612','2014120567336','3','测试测试','1417760516','1','申通快递','39','haicangku','用户2','海港区街道','1','10','145','1194','','','111111','--','13333333333','仅周末送货','','等待所有商品备齐后再发','0.00','15.00','1417763438','0','0','0');");
E_D("replace into `ecs_delivery_order` values('49','20141205073172325','2014120571955','9','','1417764424','1','申通快递','39','dongcheng_kuguan','东城','东城测试','1','2','52','500','','123@qq.com','','1333333333','13555555555','仅周末送货','','取消订单','0.00','15.00','1417764715','0','0','0');");
E_D("replace into `ecs_delivery_order` values('50','20141205091536489','2014120553559','22','2014120553559','1417770824','1','申通快递','10','shenyang_kuguang','张女士','B街C区','1','3428','3431','3440','','','','--','13812345678','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1417770905','0','0','0');");
E_D("replace into `ecs_delivery_order` values('51','20141205091653117','2014120553926','23','请输入快递单号','1417770884','1','申通快递','10','shanghai_kuguan','李女士','A街32号','1','3429','3430','3437','','','','--','13812345678','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1417770964','0','0','0');");
E_D("replace into `ecs_delivery_order` values('52','20141205091665878','2014120509929','24','请输入快递单号','1417770906','1','申通快递','10','shijiazhuang_cangku','张女士','埃及对伐啦健身房','1','10','138','1078','','','','--','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1417770990','0','0','0');");
E_D("replace into `ecs_delivery_order` values('53','20141205101050487','2014120536869','25','请输入快递单号','1417774142','1','申通快递','42','','asdas','asdasdas','1','3429','3430','3447','','','asdasd','--','13222222222','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1417774230','0','0','0');");
E_D("replace into `ecs_delivery_order` values('54','20141210023063857','2014121042819','38','','1418178382','3','圆通速递','39','海港库管','海港区太阳城','海港区太阳城街道','1','10','145','1194','','','111111','1333333333--','13333333333','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418178608','0','0','0');");
E_D("replace into `ecs_delivery_order` values('55','20141210024019066','2014121042619','37','2014121042619','1418178138','1','申通快递','44','北戴河主管','李女士','河北大街西段68号','1','10','145','1195','','','','--','13413513453','指定送货时间 12-10 今天 9:00--15:00','','等待所有商品备齐后再发','0.00','0.00','1418179259','0','0','0');");
E_D("replace into `ecs_delivery_order` values('56','20141210025237649','2014121053960','41','2014121053960','1418179462','3','圆通速递','44','北戴河主管','李女士','草场新路68号','1','10','145','1195','','','','--','13413513453','仅周末送货','快快发货！','等待所有商品备齐后再发','0.00','0.00','1418179970','0','0','0');");
E_D("replace into `ecs_delivery_order` values('57','20141210025402436','2014121051571','40','2014121051571','1418179236','3','圆通速递','42','北戴河主管','dddde','dededededede','1','10','145','1195','','','dedededed','0335-1234567-121','13323234455','指定送货时间 12-10 今天 9:00--15:00','houhouhou','等待所有商品备齐后再发','0.00','0.00','1418180059','0','0','0');");
E_D("replace into `ecs_delivery_order` values('58','20141210034197033','2014121029147','47','2014121029147','1418182760','3','圆通速递','39','北戴河主管','北戴河老虎石','北戴河老虎石某街道122号','1','10','145','1195','','','111111','11111111111111111111111111111111--','13333333333','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418182883','0','0','0');");
E_D("replace into `ecs_delivery_order` values('59','20141210034233296','2014120673259','31','请输入快递单号','1417833975','1','申通快递','10','','海港区','海港区','1','10','145','1194','','','','--','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1418182965','0','0','0');");
E_D("replace into `ecs_delivery_order` values('60','20141210051313538','2014121031412','49','','1418183620','1','申通快递','42','','asdwddd','adad','1','10','145','1195','','','adaada','121-21212-1212','13323234455','工作日/周末/假日均可','','等待所有商品备齐后再发','0.00','0.00','1418188405','0','0','0');");
E_D("replace into `ecs_delivery_order` values('61','20141210052420316','2014121010673','51','请输入快递单号','1418188957','1','申通快递','42','','asdwddd','adad','1','10','145','1195','','','adaada','121-21212-1212','13323234455','工作日/周末/假日均可','','等待所有商品备齐后再发','0.00','0.00','1418189042','0','0','0');");
E_D("replace into `ecs_delivery_order` values('62','20141210052935592','2014121038811','52','2014121038811','1418189199','3','圆通速递','39','','海港区太阳城','海港区太阳城街道','1','10','145','1194','','','111111','1333333333--','13333333333','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418189392','0','0','0');");
E_D("replace into `ecs_delivery_order` values('63','20141210053223094','2014121085890','53','请输入快递单号','1418189508','1','申通快递','42','','asdwddd','adad','1','10','145','1195','','','adaada','121-21212-1212','13323234455','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418189563','0','0','0');");
E_D("replace into `ecs_delivery_order` values('64','20141210053362635','2014121096252','50','2014121096252','1418183652','3','圆通速递','39','北戴河主管','北戴河老虎石','北戴河老虎石某街道122号','1','10','145','1195','','','111111','11111111111111111111111111111111--','13333333333','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418189618','0','0','0');");
E_D("replace into `ecs_delivery_order` values('65','20141210055346484','2014121020688','54','2014121020688','1418190659','3','圆通速递','44','admin','李女士','草场新路68号','1','10','145','1195','','','','--','13413513453','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418190787','0','0','0');");
E_D("replace into `ecs_delivery_order` values('66','20141211010525848','2014121081699','59','dddd20141204084','1418210932','1','申通快递','39','admin','海港区太阳城','海港区太阳城街道','1','10','145','1194','','','111111','1333333333--','13333333333','仅工作日送货','','等待所有商品备齐后再发','0.00','10.00','1418259915','0','0','0');");
E_D("replace into `ecs_delivery_order` values('67','20141212022530669','2014121210920','63','2014121210920','1418350910','0','','39','北京库主管','北京海淀','海淀测试','1','2','52','502','','123@qq.com','111111111','1333333333','13444444444','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418351153','0','0','0');");
E_D("replace into `ecs_delivery_order` values('68','20141212023152765','2014121215701','65','请输入快递单号','1418351399','3','圆通速递','42','admin','aaa','dhoaudhaldudhfeu','1','2','52','500','','','11121212','--','13423232323','指定送货时间 12-17 周三 9:00--15:00','','等待所有商品备齐后再发','0.00','5.56','1418351489','0','0','0');");
E_D("replace into `ecs_delivery_order` values('69','20141212023302215','2014121202491','62','请输入快递单号','1418350887','0','','44','北京库库管','于女士','中关村68号','1','2','52','502','','','','--','13456434356','仅工作日送货','请快点发货！','等待所有商品备齐后再发','0.00','10.00','1418351581','0','0','0');");
E_D("replace into `ecs_delivery_order` values('70','20141212023343480','2014121238831','64','2014121238831','1418351358','1','申通快递','44','北京库主管','王女士','A街道B区','1','2','52','500','','','','--','13434135143','仅工作日送货','请尽快发货！','等待所有商品备齐后再发','0.00','0.00','1418351626','0','0','0');");
E_D("replace into `ecs_delivery_order` values('71','20141212024153470','2014121231211','66','2014121231211','1418352038','1','申通快递','39','北京库主管','北京海淀','海淀测试','1','2','52','502','','123@qq.com','111111111','1333333333','13444444444','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418352084','0','0','0');");
E_D("replace into `ecs_delivery_order` values('72','20141212025767852','2014121255532','67','2014121255532','1418353001','0','','44','北京库库管','王女士','A街道B区','1','2','52','500','','','','--','13434135143','指定送货时间 12-13 周六 15:00--19:00','','等待所有商品备齐后再发','0.00','10.00','1418353042','0','0','0');");
E_D("replace into `ecs_delivery_order` values('73','20141212031409786','2014121213708','71','请输入快递单号','1418353921','1','申通快递','42','admin','asdwddd','adad','1','10','145','1195','','','adaada','121-21212-1212','13323234455','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418354042','0','0','0');");
E_D("replace into `ecs_delivery_order` values('74','20141212034950227','2014121276997','74','请输入快递单号','1418356082','1','申通快递','42','admin','aaa','dhoaudhaldudhfeu','1','2','52','500','','','11121212','--','13423232323','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418356142','0','0','0');");
E_D("replace into `ecs_delivery_order` values('75','20141212054339174','2014120696628','33',NULL,'1417834082','1','申通快递','44','admin','杨女士','河北大街西段268号','1','10','145','1194','','','','--','13843555532','仅工作日送货','','等待所有商品备齐后再发','0.00','15.00','1418363003','0','2','0');");
E_D("replace into `ecs_delivery_order` values('76','20141212054792649','2014121219228','69','','1418353033','3','圆通速递','10','admin','北戴河区','北戴河区','1','10','145','1195','','','','--','18712345678','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418363271','0','0','0');");
E_D("replace into `ecs_delivery_order` values('77','20141212055469040','2014121220765','75','2014121220765','1418363616','1','申通快递','44','admin','于女士','中关村68号','1','2','52','502','','','','--','13456434356','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418363673','0','0','0');");
E_D("replace into `ecs_delivery_order` values('78','20141212061923994','2014121293172','76','2014121293172','1418364142','3','圆通速递','44','北京库库管','于女士','中关村68号','1','2','52','502','','','','--','13456434356','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418365178','0','0','0');");
E_D("replace into `ecs_delivery_order` values('79','20141212070453472','2014121266026','77','2014121266026','1418364928','2','中通速递','44','北京库库管','梁女士','和平大道A街区','1','3428','3431','3439','','','','--','13334324333','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418367860','0','0','0');");
E_D("replace into `ecs_delivery_order` values('80','20141212070783172','2014121204789','78','2014121204789','1418368027','1','申通快递','44','北京库库管','于女士','中关村68号','1','2','52','502','','','','--','13456434356','仅工作日送货','','等待所有商品备齐后再发','0.00','10.00','1418368069','0','0','0');");
E_D("replace into `ecs_delivery_order` values('81','20141212082345885','2014121248131','79','2014121248131','1418372508','2','中通速递','46','68ecshopyy','杨女士','老虎石街10号','1','10','145','1195','','','','--','13909887758','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418372639','0','0','0');");
E_D("replace into `ecs_delivery_order` values('82','20141212084810865','2014121287343','80','2014121287343','1418373181','1','申通快递','46','68ecshopyy','杨女士','老虎石街10号','1','10','145','1195','','','','--','13909887758','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418374112','0','0','0');");
E_D("replace into `ecs_delivery_order` values('83','20141212091581805','2014121271854','81','2014121271854','1418375718','1','申通快递','46','68ecshopyy','杨女士','老虎石街10号','1','10','145','1195','','','','--','13909887758','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418375747','0','0','0');");
E_D("replace into `ecs_delivery_order` values('84','20141212093536714','2014121278209','82','2014121278209','1418376860','1','申通快递','46','68ecshopyy','杨女士','老虎石街10号','1','10','145','1195','','','','--','13909887758','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418376916','0','0','0');");
E_D("replace into `ecs_delivery_order` values('85','20141212095188811','2014121215678','83','2014121215678','1418377813','1','申通快递','46','68ecshopyy','杨女士','老虎石街10号','1','10','145','1195','','','','--','13909887758','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418377863','0','0','0');");
E_D("replace into `ecs_delivery_order` values('86','20141212100552015','2014121263493','84','2014121263493','1418378640','1','申通快递','46','68ecshopyy','杨女士','老虎石街10号','1','10','145','1195','','','','--','13909887758','仅工作日送货','','等待所有商品备齐后再发','0.00','0.00','1418378715','0','0','0');");

require("../../inc/footer.php");
?>